﻿/*
	Copyright (C) 2008  Ajay Handa - jmdcms.com 
	This program is free software; 
	This program is distributed in the hope that it will be useful,
	but WITHOUT ANY WARRANTY; without even the implied warranty of
	MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
	License for more details.
	Removing/Altering this copyright message is a violation of license terms.
*/

/*
	*** D O C U M E N T A T I O N ***
	---------------------------------
	1. ID: Primary Key
	2. ParentSiteID:  
	3. AliasSiteID: If provided, then this site becomes an alias for other existing site.
	4. SiteURL: URL for this site
	5. SiteFolder: Base folder for this site. This site will only have access to
			the folders under SiteFolder.
*/

IF NOT EXISTS (SELECT * FROM sysobjects WHERE type = 'U' AND name = 'JmdSite')
BEGIN
	CREATE TABLE dbo.JmdSite
	(
		ID uniqueidentifier not null ,
		ParentSiteID uniqueidentifier null,
		AliasSiteID uniqueidentifier null,
		SiteURL nvarchar(100) not null,
		SiteFolder nvarchar(100) not null,
		LastChanged timestamp not null
	 CONSTRAINT [PK_JmdSite] PRIMARY KEY CLUSTERED 
	(
		[ID] ASC
	) ON [PRIMARY]
	) ON [PRIMARY] 
END
GO


